package com.dingding.order.core.special.sql;

/**
 * 
 * @ClassName: UserSpecialOrdertSQL 
 * @Description: 专车临时订单SQL类
 * @author YHQ
 * @date 2016年12月2日 下午5:13:26
 * @since V2.5.7
 * 
 */
public class UserSpecialOrdertSQL {

	/**
	 * @author: YHQ
	 * @Description: 根据订单Id获取订单信息
	 */
	public static final String GET_USER_SPECIAL_ORDERT_BY_ID = "SELECT specialOrderId, placeOrderUserId, grabOrderUserId, placeOrderCityCode, createTime, placeOrderCity, setOutTime, setOutType, startAddress, startLongitude, startLatitude, endAddress, endLongitude, endLatitude, distance, duration, payMoney, alipayMoney, totalMoney, estimateDistance, estimateMoney, estimateDuration, payType, payTime, appointTime, aboardTime, endTime, cancelType, cancelDesc, cancelTime, publishType, orderStatus, aboardLongitude, aboardLatitude, debusLongitude, debusLatitude, routeId, depId, operatorId,vehicleLevelId FROM userspecialordert WHERE specialOrderId = ?";
	
}
